home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
fbtuning.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
2KB
|
41 lines
/* RCSVER $Id: fbtuning.sql,v 1.4 2000-01-25 13:04:57-06 randy Exp $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: fbtuning.sql
* Date: 12/28/1998
* memo: Randy Wood
* Description: Create the fbtuning table. This table contains general
* parameters ("tuning") used at the farebox.
* Changes:
************************************************************************* */
CREATE TABLE fbtuning
(
name VARCHAR2(30), /* Name of tuning variable */
val NUMBER(38), /* Value of variable */
descr VARCHAR2(80), /* Description of tuning parameter */
/* **************************************** */
/* Tabtype references the tuningtypes table */
/* Must correspond to the "type" field. */
/* **************************************** */
tabtype NUMBER(38) /* Type of parameter */
CONSTRAINT ref_fbtuning1 REFERENCES tuningtypes(type)
ON DELETE CASCADE,
/* *************************************** */
/* Fieldtype must be one of the following: */
/* 1 = Boolean field (checkbox) */
/* 2 = List field (choice) */
/* 3 = Free format (text field) */
/* */
/* If type = 2, an entry must exist in the */
/* tuningvals table. */
/* If type=3, an entry must exist in the */
/* tuningentry table. */
/* *************************************** */
fieldtype NUMBER(1),
config_num NUMBER(38)
CONSTRAINT ref_fbtuning2 REFERENCES configset(num)
ON DELETE CASCADE,
CONSTRAINT pk_fbtuning PRIMARY KEY (name, config_num)
);